package com.game.majiang.vo;

import java.sql.SQLException;
import java.util.ArrayList;

import javax.sql.rowset.CachedRowSet;

import com.game.server.db.SqlHelper;

public class MinggancikuVo {

	public int ID;
	public String SENSITIVETYPE;
	public String SENSITIVETOPIC;
	public String SENSITIVEWORDS;
	
	
	public static ArrayList<MinggancikuVo> getListMinganciku() {
		String sql = "SELECT id,SENSITIVETYPE,SENSITIVETOPIC,SENSITIVEWORDS FROM minganciku";
		CachedRowSet rs = SqlHelper.getResultSet(sql);
		ArrayList<MinggancikuVo> list = new ArrayList<MinggancikuVo>();
		try {
			while (rs.next()) 
			{
				MinggancikuVo m = new MinggancikuVo();
				m.ID = rs.getInt(1);
				m.SENSITIVETYPE = rs.getString(2);
				m.SENSITIVETOPIC = rs.getString(3);
				m.SENSITIVEWORDS = rs.getString(4);
				list.add(m);
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return list;
	}
	
}
